All Questions
Tagged with postgresqlpermissions
11 questions
0votes
1answer
872views
How can I change the PostgreSQL data folder to a shared folder location while using VirtualBox?
I'm following this tutorial that explains how to move a PostgreSQL data folder location. Basically, I just need to copy the files inside /var/lib/postgresql to a different location... Something like: ...
- 521
0votes
1answer
345views
Execute ./script.sh with a crontab
With Debian GNU/Linux 10 (buster), I'm using a simple script to save a PostgreSQL database and upload it to my Dropbox account with Dropbox-Uploader tool. I schedule this task with a crontab. When I ...
- 131
2votes
1answer
26kviews
Failed to start PostgreSQL database server
After some attempts to change permissions to access pqsql and data in /var/lib/pgsql/data/ my postgres-server failed. Postgresql status is: Loaded: loaded (/usr/lib/systemd/system/postgresql....
- 133
0votes
0answers
55views
Uploading Postgresql repo to CentOS
I've been wrestling with getting my repo set up on Vultr CentOS server, and ran into several issues. In short, I want to know how people get their backend repo up on the CentOS server. Is moving the ...
- 101
2votes
2answers
7kviews
root "su - <user>" got permission denied (Ignored)
Got permission denied when switching user from root to postgres. No issue switching from root to ubuntu. root@node-01:~# su - postgres su: Permission denied (Ignored) postgres@node-01:~$ logout root@...
- 171
0votes
2answers
6kviews
Why can't I change directory to the current directory with permission denied?
I am trying to restore a database with the following command: $ sudo -u postgres pg_restore -C -d dvdrental dvdrental.tar [sudo] password for t: However, I am receiving the following error message: ...
- 106k
2votes
0answers
895views
Use Letsencrypt certificates for Postgresql [closed]
I have successfully configured Letsencrypt for my NGINX webserver on Debian 8 Jessie. Now I have installed Postgresql 9.4 and want to use the LE certificates (in /etc/letsencrypt/live/mydomain/com/......
- 21
1vote
1answer
1kviews
Failed to start PostgreSQL 9.5 with systemctl - SELinux
I've installed PG 9.5 (/usr/pgsql-9.5/) and when I start it manually with postgres -D it has no problems, but if I try to use systemctl I get an error. By looking to journalctl -xen output, I see: /...
- 121
2votes
1answer
2kviews
Ways to restrict remote user to only access a remote database
I want to be able to setup a remote user that can update a PostgreSQL database on a production server. I have two machines, one is a local server that I use as a command and control system, named ...
- 133
2votes
4answers
10kviews
Permanently change permissions of /var/run/postgresql
On Linux Mint 17.0 Cinnamon Edition, I want to use /var/run/postgresql as the unix_socket_directories option for all of my postgres databases. Whenever I run the command pg_ctl -D postgres-data -o '-...
2votes
2answers
11kviews
postgresql service start issues
I'm attempting to build a box via Fabric on Openstack. Part of the install involves installing and running PostgreSQL. This command works fine: $ sudo service postgresql initdb This command fails: ...
- 463
